
	
	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Owners]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) DROP PROCEDURE [Owners]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[AllTypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [AllTypes]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[AllTypesComplex]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [AllTypesComplex]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[MachineConfigs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [MachineConfigs]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[OwnerOwnerDetails]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [OwnerOwnerDetails]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[OwnerContactInfos]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [OwnerContactInfos]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[RunOwners]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [RunOwners]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[TaskResults]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [TaskResults]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[TaskInvestigates]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [TaskInvestigates]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[FailureTypes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [FailureTypes]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[FailureDetails]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [FailureDetails]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[ConfigFailures]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [ConfigFailures]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[BugsDefectTracking]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [BugsDefectTracking]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[BugsProjectTracking]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [BugsProjectTracking]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[TestScenarios]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [TestScenarios]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[DeploymentScenarios]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [DeploymentScenarios]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Testers]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [Testers]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Configs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [Configs]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Owners]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [Owners]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[OwnerDetails]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [OwnerDetails]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Tasks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [Tasks]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Failures]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [Failures]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Projects]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [Projects]

	 IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Runs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE [Runs]

